UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6z4ZdOonTSjBLihPCjLwrV2xYsKK52ZBxio9m3l1HEc='
WHERE
key_id = '930b179b39814873bc8097329d1b00cca0077a28741f3e5237631964bbc0302a'
AND (
token = '6z4ZdOonTSjBLihPCjLwrV2xYsKK52ZBxio9m3l1HEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)