UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtVpPVdaZ0yMT1rRkwKyqdANRO1kDxuT4thhuWkO/5s='
WHERE
key_id = 'a8d94cfbc9f5d6907aa668e12df26ac90c1a5220aeb176598c91cd922ab3fe00'
AND (
token = 'BtVpPVdaZ0yMT1rRkwKyqdANRO1kDxuT4thhuWkO/5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)