UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NT3qdcZ2zaGI1l+RxBHU0y8b93eC2FKpUI7k+108Rvk=' 
WHERE 
  key_id = '9dc53442d9b08a6b3413816f06b799583d0a3e570f78072f3b2820f55000f120' 
  AND (
    token = 'NT3qdcZ2zaGI1l+RxBHU0y8b93eC2FKpUI7k+108Rvk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019