UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'dWAZB95N4/CTaBcvv1Y481w2Z1bMloh4KpJuSzUKrBA=' 
WHERE 
  key_id = '0156bc2fd34b9dc9f2f261c0213a30aada0bb9101ff14d8719ab90bb9653660b' 
  AND (
    token = 'dWAZB95N4/CTaBcvv1Y481w2Z1bMloh4KpJuSzUKrBA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044