UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+tooGG8QbLrW+4XTs0a3YWJEUpCofb6nb8OjWV+FfQ='
WHERE
key_id = '59e122df79b2754beffa01454246f227301b8139bfafa24fd1ee33dc8fa09d0b'
AND (
token = '9+tooGG8QbLrW+4XTs0a3YWJEUpCofb6nb8OjWV+FfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)