UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Vcu1W7sH89PJyHfHz8u7MU6E/aHO0mxrNFWy0ni6CKI=' 
WHERE 
  key_id = '09e98cbdaeb5f641951273b02428a81d2a2d0adab418c923307e991bc721e8d6' 
  AND (
    token = 'Vcu1W7sH89PJyHfHz8u7MU6E/aHO0mxrNFWy0ni6CKI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026