UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IcgLybYJi+urvmCplarBdV8iN2OipuSxmzGS0ZFzjqU='
WHERE
key_id = '3ac9d87e73cf6b3a26641eff42eee66acfedb097be16674d699fe47724a0f223'
AND (
token = 'IcgLybYJi+urvmCplarBdV8iN2OipuSxmzGS0ZFzjqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)