UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZeOtM0QhtOFpENjyBYDK7LsT6V1TaIhhxQCveyeDqN0='
WHERE
key_id = '05c72c7c23e8beb562e56fb039a2ed311c3258b7780b24b19dca38d0470d60dd'
AND (
token = 'ZeOtM0QhtOFpENjyBYDK7LsT6V1TaIhhxQCveyeDqN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)