UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KM+ThSUM/OFffNeN4KUwev+2tOsqz7BPlmOShiCTbU='
WHERE
key_id = '54acdfbae54f9c6d814b17cfddb0b731453883e80a8a70eaaf32f2e9ae330ab1'
AND (
token = '/KM+ThSUM/OFffNeN4KUwev+2tOsqz7BPlmOShiCTbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)