UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'A6lNKjHbI5CNfR+R2rH4DTtr0nq/8Hu9ggYHDLz5tTA=' 
WHERE 
  key_id = '2c81d252e679ce6c9cd940870d38377900cb9e38e1ee4618152ed518b2d00ac5' 
  AND (
    token = 'A6lNKjHbI5CNfR+R2rH4DTtr0nq/8Hu9ggYHDLz5tTA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023