UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M0P2xLa6peZaY2k068T5JRN07SwowD9HiEwb97jf2go='
WHERE
key_id = 'f059816f59bd05267ab15fe3df64aae37ea863ae8667f9a7e4a589a67b007daf'
AND (
token = 'M0P2xLa6peZaY2k068T5JRN07SwowD9HiEwb97jf2go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)