UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ClJ44XIj1H24KwfPrTtLdtzknLd8SjUBEd6v99UVJtI=' 
WHERE 
  key_id = '1488166130b54de11af06761a53571637dbfc9ac360b85db7c0431f8ecd308fd' 
  AND (
    token = 'ClJ44XIj1H24KwfPrTtLdtzknLd8SjUBEd6v99UVJtI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027