UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0NHDXWQy0Tj4+UGWpbNO/ss7Af+sKkn8CnXzP98QCrs='
WHERE
key_id = 'b1fa48904f5d783dbbeea991858715a73cedcb03e6cb8de14c82ad3209075063'
AND (
token = '0NHDXWQy0Tj4+UGWpbNO/ss7Af+sKkn8CnXzP98QCrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)