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