UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Aszqr+W9UbX43Hzy7ajqcmz7WD74+0bv1HdmPqLGjSI=' 
WHERE 
  key_id = '4ce15869bf48d49d55f35d06fd26347cb7da3a9fd87e428b8e5032b6bbafe56e' 
  AND (
    token = 'Aszqr+W9UbX43Hzy7ajqcmz7WD74+0bv1HdmPqLGjSI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045