UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mcrKhHT5/dlX7G/P+DgcFDX15aW6xOyeLrUajBamoyM=' 
WHERE 
  key_id = '42fe0083e87acdfa605c738c471bba1894b4da37d3ca4b8c508985c54dc1d4ef' 
  AND (
    token = 'mcrKhHT5/dlX7G/P+DgcFDX15aW6xOyeLrUajBamoyM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033