UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ztIzAnBv1xnEcC8G7DjGtICQL44l8CKH4UIyD6q3nw4=' 
WHERE 
  key_id = '3cffb84de563838c8d0463c169bacc19393ad7f40124ec7253ff3837d703eaec' 
  AND (
    token = 'ztIzAnBv1xnEcC8G7DjGtICQL44l8CKH4UIyD6q3nw4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043