UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u0yncawJhAztUSLnhBhlfA8trR+yLNsNEOUjxx3+3rI='
WHERE
key_id = '4db65ce4631d12faa86338c3274547953d99f1e442bde77e3de0e207853da6dc'
AND (
token = 'u0yncawJhAztUSLnhBhlfA8trR+yLNsNEOUjxx3+3rI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)