UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4p1AHZiy13qvUDSaLhs1/ZSdcgWl+ye3oI3SRiRP7IM='
WHERE
key_id = '04d95af3d6e6da0712214a67b04f491a22d09f5e71c8966954b074ce45abe447'
AND (
token = '4p1AHZiy13qvUDSaLhs1/ZSdcgWl+ye3oI3SRiRP7IM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)