UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQ5lqyX/TAD7kmJAK2gMpocT5CSoIDdGo5WGC9SnGeM='
WHERE
key_id = 'a06986a39ab1b6801ed20868aa63a9671eda34af0b4da37f1912accdc3b1c9b2'
AND (
token = 'gQ5lqyX/TAD7kmJAK2gMpocT5CSoIDdGo5WGC9SnGeM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)