UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'b4LU03RYP41a3kA89zq6BvTt7tqkog7BJWyxBWxHZzk=' 
WHERE 
  key_id = 'd7bd074e6923fab3938bff9cef8bc0f43e1851df7ce57b57a0074ef6f53dabe9' 
  AND (
    token = 'b4LU03RYP41a3kA89zq6BvTt7tqkog7BJWyxBWxHZzk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040