UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zb0/oPZ9tV/4YJlL2ZmNwhxALVgXyDD2UDTBhtA7bhg='
WHERE
key_id = 'b05857892054bf08cc504ddf26ca14ca5f96745f9bb24a8d0cc3c485b345d015'
AND (
token = 'zb0/oPZ9tV/4YJlL2ZmNwhxALVgXyDD2UDTBhtA7bhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)