UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8IcHXxuYE/G3m4WKt8o6Q0Xiv1754HbWLl/LMw+u8w4='
WHERE
key_id = '803695827025a386147ad177f440c019936c3e268b900606b772daea07d6237c'
AND (
token = '8IcHXxuYE/G3m4WKt8o6Q0Xiv1754HbWLl/LMw+u8w4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)