UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qHJy7Wn0fEOIZDz+adDxyikX5K8PCogRybabBKVJvhY='
WHERE
key_id = '96820e0cddf895ddfaa3575cf8928ce100c78bced035f30e35146824e4d2d61f'
AND (
token = 'qHJy7Wn0fEOIZDz+adDxyikX5K8PCogRybabBKVJvhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)