UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8Nd8iZBSAOF3XE8QOI2B7vJdV2OckbMZ0P2B9zS+H3w=' 
WHERE 
  key_id = '24240516354143fb6bcee371c232d186fa72a8766311bad0456688cb3e1eacd3' 
  AND (
    token = '8Nd8iZBSAOF3XE8QOI2B7vJdV2OckbMZ0P2B9zS+H3w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023