UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXDmfZGcjT+IuO5/rCncmiw18rqoQX+C+9T5lkeuAKw='
WHERE
key_id = 'c277f7ea395cc5f926589a06c17621016b3cc3e8ec8130344b4e63715f4dfaa5'
AND (
token = 'KXDmfZGcjT+IuO5/rCncmiw18rqoQX+C+9T5lkeuAKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)