UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I4iOuMGODknzjSM/L2huqNjUfbSPrqrhRAMAtEQFLKA='
WHERE
key_id = 'bb367a83e46db8ec70e289b260a84c889b77328cc6f92642f543833ca81891c3'
AND (
token = 'I4iOuMGODknzjSM/L2huqNjUfbSPrqrhRAMAtEQFLKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)