UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfkpyUXw2XwLlUqzKGhha3PIpqDbeKFl04eRic9JOjI='
WHERE
key_id = '4a51c5de149874876b834d8a0e68c4564acbca16b4665e316e5fc8818ef71ffa'
AND (
token = 'hfkpyUXw2XwLlUqzKGhha3PIpqDbeKFl04eRic9JOjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)