UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCMInGiZPZimXxE1BtNgIx66qtsgvzZtJQEQw4dIVHw='
WHERE
key_id = 'b57a62505b8e2453eda79cfba085494ff301a9a27e238c42d7f754074d3e5126'
AND (
token = 'ZCMInGiZPZimXxE1BtNgIx66qtsgvzZtJQEQw4dIVHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)