UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+9xwNZ3S8UW8p9hEyRuRi4vZKiWe7Xhjo+3ac8OUZOk=' 
WHERE 
  key_id = '269892ee02e887755ec2372e3fea8391384f516f40bde096c5fdbb026b9f26e5' 
  AND (
    token = '+9xwNZ3S8UW8p9hEyRuRi4vZKiWe7Xhjo+3ac8OUZOk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022