UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hO2v24Nf+G7vYpC3/JVSrTZODLnrk01PhgmqISKGhw='
WHERE
key_id = '1ca9b6336969a7c9762f27c1856f0ccb2826e804f37db418331d6df8b535fa54'
AND (
token = '6hO2v24Nf+G7vYpC3/JVSrTZODLnrk01PhgmqISKGhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)