UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1tpcE693JALTKAVy7nBB4w9eMDW2WMZoInKZlc7G1Vs='
WHERE
key_id = '808bddf4e6ba96d4af629bda0f330cfd973501de6d0f3808d5ba7593e10338b6'
AND (
token = '1tpcE693JALTKAVy7nBB4w9eMDW2WMZoInKZlc7G1Vs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)