UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgvKN/U9bgTJ2ffTzDci29qwgfX5jYLj/3uy5QkT2zg='
WHERE
key_id = 'e97cc1c6463cd642504f6bea524aea0b0420d2f8d93073604df0e7b9a8ad7be0'
AND (
token = 'xgvKN/U9bgTJ2ffTzDci29qwgfX5jYLj/3uy5QkT2zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)