UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ogc7+a6DF23wkOxLPvKkyaUcftmLCaBtLaQWEaA6bY='
WHERE
key_id = '5cf3595b114271198a4243ce2ee1873b1b5b90b57aaee9555d59859259afcbda'
AND (
token = '8ogc7+a6DF23wkOxLPvKkyaUcftmLCaBtLaQWEaA6bY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)