UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'PWBmd5Y/XQ4OMhShXxQ7QHenRbKsU6yqJGw94h6T+yM=' 
WHERE 
  key_id = 'bc807757d7eddd67177ef9f17987d798abde495a857e756696288ce3ba5bd201' 
  AND (
    token = 'PWBmd5Y/XQ4OMhShXxQ7QHenRbKsU6yqJGw94h6T+yM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023