UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h4LykzuAGTD+jqji48G/SgKj8eEGVx1AoKDVB/wjlvU='
WHERE
key_id = 'b8ce7e5f8cb569e946963ef96ab548cb761b1f06205c6f66f3be4929a3525ada'
AND (
token = 'h4LykzuAGTD+jqji48G/SgKj8eEGVx1AoKDVB/wjlvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)