UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+KPK8boNzwcpu7ONnKBp0kNTHGkkDCRykI/MsHju1jM=' 
WHERE 
  key_id = 'cae27cfaffe65d1af9b138f57b00e6d75f5d711dcd0c93dc93f40283c0a6e2dc' 
  AND (
    token = '+KPK8boNzwcpu7ONnKBp0kNTHGkkDCRykI/MsHju1jM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026