UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1j/0ugofknI7iscJpRElZ229FQZGIIR+TiM03FHDkzs='
WHERE
key_id = '6bc27013c3f43f1cc0db01ef2af3a29622c5a17ee9e3acd3d4b105c3b40e001b'
AND (
token = '1j/0ugofknI7iscJpRElZ229FQZGIIR+TiM03FHDkzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)