UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ziv88lVQi38rPR+LlXafs41Bj0gwO7VWB90LNpV0xCI=' 
WHERE 
  key_id = '7b96c297d23250ac40c37e42053f61a52f0972ca7069354985169ad735536150' 
  AND (
    token = 'ziv88lVQi38rPR+LlXafs41Bj0gwO7VWB90LNpV0xCI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021