UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RNzTvkY2gZNEUm/Or7LvUQRmMD/d2XUmaZFQCD77aRA='
WHERE
key_id = 'c0f4ed6cd7037e647f13be9f6f0cae9718031cc7f351fde789052fcf42e07cc5'
AND (
token = 'RNzTvkY2gZNEUm/Or7LvUQRmMD/d2XUmaZFQCD77aRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)