UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gfv7k1H8vdSipEWdjsaiogq6NKInPjH/S/NkqIDZ3g='
WHERE
key_id = 'ba0e4b227f3f7f2df24c224079c15de70f2265b6e0ef8a6f45676a10374e4aac'
AND (
token = '0gfv7k1H8vdSipEWdjsaiogq6NKInPjH/S/NkqIDZ3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)