UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3Pd5sL9rSKshD0ukvz1rcSeI6vBJ/5SH03bU02nX3H8=' 
WHERE 
  key_id = '1212bf0051ef5ac91c98ea81e7f5f0a806b76b3fe791ccd7c5fa58a69fa1cfdf' 
  AND (
    token = '3Pd5sL9rSKshD0ukvz1rcSeI6vBJ/5SH03bU02nX3H8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027