UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/PTgug/foJp9tl7E2KiDBdQK8KXXAf0CXPIxjfuafjs='
WHERE
key_id = '477068032299d91382d2c97b762686187ad00717989fd0e0660a8651f4aaac7e'
AND (
token = '/PTgug/foJp9tl7E2KiDBdQK8KXXAf0CXPIxjfuafjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)