UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LYquFARWVsXTeBQYDu/UweYTn0DvMcULhTD39x0NJv0=' 
WHERE 
  key_id = '38bcdd974e47cd8bcfb383f6d1027d7a5b80dcef556a20c09f9a61a325488b78' 
  AND (
    token = 'LYquFARWVsXTeBQYDu/UweYTn0DvMcULhTD39x0NJv0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022