UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xhe5BUo4GY7M5IhptRIufHZ5+tsKp4sPHwiXwt7P5P0=' 
WHERE 
  key_id = 'c29cd0b176d9810f9a1cfdc1ac2c8318022dbf7322a3257cbdbb371a1bc648cb' 
  AND (
    token = 'xhe5BUo4GY7M5IhptRIufHZ5+tsKp4sPHwiXwt7P5P0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023